FieldValue

Gets or sets individual fields in a query.

Parameters

FieldName. Specifies the field name.

Examples

var value;
value = Query.FieldValue("MyField");

Retrieves a field named MyField.

var value;
value=Query("MyField");

Retrieves a field named MyField

var Query;
Query = CRM.CreateQueryObj("Select * from company", "");
Query.SelectSql();
while (!Query.eof)
{
CRM.AddContent(Query("comp_companyid") + " = " + Query("comp_name") + " ");
Query.NextRecord();
}
Response.Write(CRM.GetPage());

Displays the company identifier and the name field from the selected SQL query.